# Using Microsoft SQL Server as a source

This section describes how to set up and use a Microsoft SQL Server database as the source database in a replication task.

In this section:

* [Supported editions](https://help.qlik.com/en-US/replicate/November2025/Content/Global_Common/Content/SharedReplicateHDD/SQLServer-Source/Supported_editions.htm)
* [Prerequisites](https://help.qlik.com/en-US/replicate/November2025/Content/Global_Common/Content/SharedReplicateHDD/SQLServer-Source/prereqs_sql_server.htm)
* [Limitations and considerations](https://help.qlik.com/en-US/replicate/November2025/Content/Global_Common/Content/SharedReplicateHDD/SQLServer-Source/limitations_source_SQLServerDB.htm)
* [Working with Microsoft SQL Server AlwaysOn Availability Groups](https://help.qlik.com/en-US/replicate/November2025/Content/Global_Common/Content/SharedReplicateHDD/SQLServer-Source/work_with_sql_server_alwayson_availability_groups.htm)
* [Required permissions](https://help.qlik.com/en-US/replicate/November2025/Content/Global_Common/Content/SharedReplicateHDD/SQLServer-Source/SQLServerDBSource_Security.htm)
* [Supported compression methods](https://help.qlik.com/en-US/replicate/November2025/Content/Global_Common/Content/SharedReplicateHDD/SQLServer-Source/supported_compression_methods_sql_server.htm)
* [Microsoft SQL Server source data types](https://help.qlik.com/en-US/replicate/November2025/Content/Replicate/Main/SQL%20Server/SQLServerDB_source_DataTypes.htm#ar_sqlserverds_1727505754_1656412)
* [Homogeneous replication](https://help.qlik.com/en-US/replicate/November2025/Content/Replicate/Main/SQL%20Server/Homogeneous_Replication.htm#ar_sqlserverds_1727505754_1659696)
* [Preparing the Microsoft SQL Server database for CDC](https://help.qlik.com/en-US/replicate/November2025/Content/Global_Common/Content/SharedReplicateHDD/SQLServer-Source/SQLServerDBSource_ConfigAR.htm)
* [Setting general connection properties](https://help.qlik.com/en-US/replicate/November2025/Content/Replicate/Main/SQL%20Server/SQLServerDB_DiaBox_source.htm#ar_sqlserverds_1727505754_1657850)
* [Setting advanced connection properties](https://help.qlik.com/en-US/replicate/November2025/Content/Replicate/Main/SQL%20Server/SQLServerDBSource_AdvProps.htm#ar_sqlserverds_1727505754_1669928)
* [Working with Windows authentication](https://help.qlik.com/en-US/replicate/November2025/Content/Replicate/Main/SQL%20Server/Work_with_Windows_Authentication.htm)
* [Artifacts created by Replicate in the database](https://help.qlik.com/en-US/replicate/November2025/Content/Replicate/Main/SQL%20Server/remove_artifacts.htm)